Formula Ribbon

  • Run Button: as in other modules, click the Pyramid run button to test your formulations.
  • Clipboard tools: use the clipboard tools to cut, copy, paste, and delete. You can also use keyboard shortcuts for these functions.
  • Clear All: clear everything from the canvas.
  • Script Mode: Click to switch to script mode and build you formula or list using PQL in the Custom Member IDE or the Custom List IDE.
  • Reset zoom to default: reset to the default zoom.
  • Blocks Size:set the formula blocks size to small, medium, or large.
  • Marketplace: select a formula from the Marketplace drop down.
  • Choose Language: change the language for metadata and queries.
  • Translate Source: translate the formula name to be used for metadata and queries.
  • Refresh Metadata: refresh the data model metadata, including dimensions, elements, and business logic.
  • Quick Discovery: click to open the formulation in Discover. Click here for more information.
  • Quick Logic: open build a formula, list, KPI, parameter or custom column in a new tab.